Overview

DuneSQL supports a wide range of built-in functions and operators.

This chapter describes the built-in SQL functions and operators supported by Trino. They allow you to implement complex functionality and behavior of the SQL executed by Trino operating on the underlying data sources.

Using SHOW FUNCTIONS in the query editor returns a list of all available functions, including custom functions, with all supported arguments and a short description.

DuneSQL Added Functions:

• Varbinary datatypes for EVM data
• Base58 for Bitcoin&Solana data
• ss58 for Substrate data
• Tron Address Functions
• Chain Utility Functions
• Varchar Utility Functions
• LiveFetch Functions

Trino Base Functions:

• Aggregate
• Array
• Binary
• Bitwise
• Comparison
• Conditional
• Conversion
• Date and time
• Decimal
• HyperLogLog
• JSON
• Lambda
• Logical
• Map
• Math
• Quantile digest
• Regular expression
• Set Digest
• String
• System
• Teradata
• T-Digest
• URL
• UUID
• Window